INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('中坝00MA5600                          '),trim('DSLAM      '),trim('192.168.96.11       '),trim('192.168.96.11           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金庭小区00MA5600                      '),trim('DSLAM      '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局麦地村00MA5600                    '),trim('DSLAM      '),trim('192.168.96.12       '),trim('192.168.96.12           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('云南印象54栋00MA5600                  '),trim('DSLAM      '),trim('192.168.96.13       '),trim('192.168.96.13           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区00MA5600                      '),trim('DSLAM      '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局华春园00MA5600                    '),trim('DSLAM      '),trim('192.168.96.14       '),trim('192.168.96.14           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金实南00MA5600                    '),trim('DSLAM      '),trim('192.168.96.15       '),trim('192.168.96.15           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('裕康花园00MA5600                      '),trim('DSLAM      '),trim('192.168.96.16       '),trim('192.168.96.16           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局江东四季园04MA5600                '),trim('DSLAM      '),trim('192.168.96.17       '),trim('192.168.96.17           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局江东丽景园01MA5600                '),trim('DSLAM      '),trim('192.168.96.18       '),trim('192.168.96.18           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局波罗村02MA5600                    '),trim('DSLAM      '),trim('192.168.96.19       '),trim('192.168.96.19           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局江东丽景园02MA5600                '),trim('DSLAM      '),trim('192.168.96.20       '),trim('192.168.96.20           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金庭小区01MA5600                  '),trim('DSLAM      '),trim('192.168.96.21       '),trim('192.168.96.21           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金庭小区02MA5600                  '),trim('DSLAM      '),trim('192.168.96.22       '),trim('192.168.96.22           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局白龙小区02MA5600                  '),trim('DSLAM      '),trim('192.168.96.23       '),trim('192.168.96.23           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局盘检院00MA5100                    '),trim('DSLAM      '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局盘检院02MA5100                    '),trim('DSLAM      '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局丹彤大厦00MA5600                  '),trim('DSLAM      '),trim('192.168.96.24       '),trim('192.168.96.24           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局华春园02MA5100                    '),trim('DSLAM      '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局丹彤大厦01MA5600                  '),trim('DSLAM      '),trim('192.168.96.25       '),trim('192.168.96.25           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局丹彤大厦02MA5600                  '),trim('DSLAM      '),trim('192.168.96.26       '),trim('192.168.96.26           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局大波村00MA5600                    '),trim('DSLAM      '),trim('192.168.96.27       '),trim('192.168.96.27           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S8505-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金实西00MA5100                    '),trim('DSLAM      '),trim('192.168.96.80       '),trim('192.168.96.80           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金实西01MA5100                    '),trim('DSLAM      '),trim('192.168.96.81       '),trim('192.168.96.81           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('时光俊园02ZX9210                      '),trim('DSLAM      '),trim('192.168.96.83       '),trim('192.168.96.83           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局华为OLT2                          '),trim('OLT        '),trim('192.168.126.11      '),trim('192.168.126.11-75       '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局烽火OLT2(是否开？)              '),trim('OLT        '),trim('192.168.146.34      '),trim('192.168.146.34-60       '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('财富中心华为OLT                       '),trim('OLT        '),trim('192.168.142.2       '),trim('192.168.142.2-33        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东丽景园华为OLT                     '),trim('OLT        '),trim('192.168.142.162     '),trim('192.168.142.162-193     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('时光俊园01ZX9210                      '),trim('OLT        '),trim('192.168.96.82       '),trim('192.168.96.82           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('时光俊园01ZX9210                      '),trim('OLT        '),trim('192.168.146.2       '),trim('192.168.146.2-33        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局中兴OLT3                          '),trim('OLT        '),trim('192.168.146.141     '),trim('192.168.146.141-160     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局OLT4(中兴)                        '),trim('OLT        '),trim('192.168.193.2       '),trim('192.168.193.2-50        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金实北OLT1(中兴)                    '),trim('OLT        '),trim('192.168.193.51      '),trim('192.168.193.51-100      '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('中产风尚华为OLT1(FTTH)                '),trim('OLT        '),trim('172.30.88.129       '),trim('172.30.88.129/26        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金实北OLT1(华为)                    '),trim('OLT        '),trim('192.168.193.101     '),trim('192.168.193.101-150     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('滨江俊园OLT1(华为)                  '),trim('OLT        '),trim('192.168.193.151     '),trim('192.168.193.151-220     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金色年华华为 OLT2(FTTH)              '),trim('OLT        '),trim('172.30.87.129       '),trim('172.30.87.129/65        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东好世界华为 OLT3(FTTH)             '),trim('OLT        '),trim('172.30.87.193       '),trim('172.30.87.193/65        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东好世界华为 OLT4(FTTH)            '),trim('OLT        '),trim('172.30.88.1         '),trim('172.30.88.1/65          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('盘龙区新政府WLAN1                     '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('盘龙区新政府WLAN2                     '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('国美苏宁颐高数码                      '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('政法干部学校(WLAN)                  '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('科技信息职业学院穿金校区(WLAN)      '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局汇聚WLAN                          '),trim('L2         '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('时光俊园LAN                           '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金兰水榭WLAN                          '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局江东好世界01ZX9210                '),trim('DSLAM      '),trim('192.168.96.33       '),trim('192.168.96.33           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局10MA5600                          '),trim('DSLAM      '),trim('192.168.96.35       '),trim('192.168.96.35           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局11MA5600                          '),trim('DSLAM      '),trim('192.168.96.36       '),trim('192.168.96.36           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局华夏园04MA5600                    '),trim('DSLAM      '),trim('192.168.96.37       '),trim('192.168.96.37           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金泉小区03MA5600                  '),trim('DSLAM      '),trim('192.168.96.38       '),trim('192.168.96.38           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金泉小区04MA5600                  '),trim('DSLAM      '),trim('192.168.96.39       '),trim('192.168.96.39           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局樱花山谷02MA5600                  '),trim('DSLAM      '),trim('192.168.96.40       '),trim('192.168.96.40           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金色家园02ZX9210                      '),trim('DSLAM      '),trim('192.168.96.41       '),trim('192.168.96.41           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金色家园03ZX9210                      '),trim('DSLAM      '),trim('192.168.96.42       '),trim('192.168.96.42           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('桂花苑                                '),trim('DSLAM      '),trim('192.168.96.44       '),trim('192.168.96.44           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金色年华00MA5600                      '),trim('DSLAM      '),trim('192.168.96.46       '),trim('192.168.96.46           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局12MA5600                          '),trim('DSLAM      '),trim('192.168.96.47       '),trim('192.168.96.47           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局13MA5600                          '),trim('DSLAM      '),trim('192.168.96.48       '),trim('192.168.96.48           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局14MA5600                          '),trim('DSLAM      '),trim('192.168.96.49       '),trim('192.168.96.49           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局15MA5600                          '),trim('DSLAM      '),trim('192.168.96.50       '),trim('192.168.96.50           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区03ZX9210                      '),trim('DSLAM      '),trim('192.168.96.52       '),trim('192.168.96.52           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('实力北岸04ZX9210                      '),trim('DSLAM      '),trim('192.168.96.53       '),trim('192.168.96.53           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('财富中心01ZX9210                      '),trim('DSLAM      '),trim('192.168.96.55       '),trim('192.168.96.55           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('骊岛家园01ZX9210                      '),trim('DSLAM      '),trim('192.168.96.56       '),trim('192.168.96.56           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东好世界02ZX9210                    '),trim('DSLAM      '),trim('192.168.96.57       '),trim('192.168.96.57           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56ZN                                  '),trim('DSLAM      '),trim('192.168.96.58       '),trim('192.168.96.58           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56ZO                                  '),trim('DSLAM      '),trim('192.168.96.59       '),trim('192.168.96.59           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56ZP                                  '),trim('DSLAM      '),trim('192.168.96.60       '),trim('192.168.96.60           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56ZQ                                  '),trim('DSLAM      '),trim('192.168.96.61       '),trim('192.168.96.61           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东花城00ZX9210                      '),trim('DSLAM      '),trim('192.168.96.62       '),trim('192.168.96.62           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东花城01ZX9210                      '),trim('DSLAM      '),trim('192.168.96.63       '),trim('192.168.96.63           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金康园00MA5600                        '),trim('DSLAM      '),trim('192.168.96.64       '),trim('192.168.96.64           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东丽景园03MA5600                    '),trim('DSLAM      '),trim('192.168.96.65       '),trim('192.168.96.65           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东花城03ZX9210                      '),trim('DSLAM      '),trim('192.168.96.66       '),trim('192.168.96.66           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('云南印象54幢02MA5600                  '),trim('DSLAM      '),trim('192.168.96.67       '),trim('192.168.96.67           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('羊肠大村01MA5600                      '),trim('DSLAM      '),trim('192.168.96.68       '),trim('192.168.96.68           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56ZR                                  '),trim('DSLAM      '),trim('192.168.96.94       '),trim('192.168.96.94           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56ZS                                  '),trim('DSLAM      '),trim('192.168.96.95       '),trim('192.168.96.95           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局03ZX9210                          '),trim('DSLAM      '),trim('192.168.96.96       '),trim('192.168.96.96           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局04ZX9210                          '),trim('DSLAM      '),trim('192.168.96.97       '),trim('192.168.96.97           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局华夏园05MA5600                    '),trim('DSLAM      '),trim('192.168.96.140      '),trim('192.168.96.140          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('春城邻里华为OLT                       '),trim('OLT        '),trim('192.168.146.66      '),trim('192.168.146.66-97       '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局EPON OLT-02(烽火)                 '),trim('OLT        '),trim('192.168.96.45       '),trim('192.168.96.45           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('时光俊园华为OLT                       '),trim('OLT        '),trim('192.168.142.2       '),trim('192.168.142.2-65        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('实力北岸华为OLT                       '),trim('OLT        '),trim('192.168.142.98      '),trim('192.168.142.98-129      '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('云南印象60幢华为OLT                   '),trim('OLT        '),trim('192.168.142.194     '),trim('192.168.142.194-225     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金泉小区OLT2(hw)                      '),trim('OLT        '),trim('192.168.146.34      '),trim('192.168.146.34-65       '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局OLT3(hw)                          '),trim('OLT        '),trim('192.168.146.100     '),trim('192.168.146.100-140     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金实北华为OLT2(FTTH)                  '),trim('OLT        '),trim('192.168.234.129     '),trim('192.168.234.129/26      '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('白龙小区龙华路146号华为OLT1(FTTH)     '),trim('OLT        '),trim('192.168.234.65      '),trim('192.168.234.65/26       '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局OLT4(hw)                          '),trim('OLT        '),trim('192.168.146.201     '),trim('192.168.146.201-240     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('王旗营万福里机房华为OLT1(FTTH)      '),trim('OLT        '),trim('172.30.88.193       '),trim('172.30.88.193/26        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('巨和美术小区中兴OLT1(FTTH)          '),trim('OLT        '),trim('172.30.87.1         '),trim('172.30.87.1/65          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('巨和美术小区中兴OLT2(FTTH)          '),trim('OLT        '),trim('172.30.87.65        '),trim('172.30.87.65/65         '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金实北华为OLT3(FTTH)                  '),trim('OLT        '),trim('192.168.234.193     '),trim('192.168.234.193/26      '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('世纪俊园LAN                           '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-2                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('实力北岸05ZX9210                      '),trim('DSLAM      '),trim('192.168.96.122      '),trim('192.168.96.122          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('道明汽配城01ZX9210                    '),trim('DSLAM      '),trim('192.168.96.125      '),trim('192.168.96.125          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局白龙小区03MA5600                  '),trim('DSLAM      '),trim('192.168.96.126      '),trim('192.168.96.126          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区04ZX9210                      '),trim('DSLAM      '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('春城邻里02ZX9210                      '),trim('DSLAM      '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('葵花公社02ZX9210                      '),trim('DSLAM      '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金洲湾蓝屿03MA5600                '),trim('DSLAM      '),trim('192.168.96.101      '),trim('192.168.96.101          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('盘检院A                               '),trim('DSLAM      '),trim('192.168.96.102      '),trim('192.168.96.102          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('盘检院D                               '),trim('DSLAM      '),trim('192.168.96.103      '),trim('192.168.96.103          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('盘检院E                               '),trim('DSLAM      '),trim('192.168.96.104      '),trim('192.168.96.104          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金实北A                               '),trim('DSLAM      '),trim('192.168.96.105      '),trim('192.168.96.105          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金实北B                               '),trim('DSLAM      '),trim('192.168.96.106      '),trim('192.168.96.106          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金康园A                               '),trim('DSLAM      '),trim('192.168.96.107      '),trim('192.168.96.107          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东四季园接入网A                     '),trim('DSLAM      '),trim('192.168.96.108      '),trim('192.168.96.108          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东四季园接入网C                     '),trim('DSLAM      '),trim('192.168.96.109      '),trim('192.168.96.109          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区A                             '),trim('DSLAM      '),trim('192.168.96.110      '),trim('192.168.96.110          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区B                             '),trim('DSLAM      '),trim('192.168.96.111      '),trim('192.168.96.111          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区C                             '),trim('DSLAM      '),trim('192.168.96.112      '),trim('192.168.96.112          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区D                             '),trim('DSLAM      '),trim('192.168.96.113      '),trim('192.168.96.113          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金康园D                               '),trim('DSLAM      '),trim('192.168.96.114      '),trim('192.168.96.114          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金康园B                               '),trim('DSLAM      '),trim('192.168.96.115      '),trim('192.168.96.115          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金洲湾篮屿00MA5100                '),trim('DSLAM      '),trim('192.168.96.116      '),trim('192.168.96.116          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局金洲湾篮屿02MA5100                '),trim('DSLAM      '),trim('192.168.96.117      '),trim('192.168.96.117          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东花城A                             '),trim('DSLAM      '),trim('192.168.96.118      '),trim('192.168.96.118          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东花城B                             '),trim('DSLAM      '),trim('192.168.96.119      '),trim('192.168.96.119          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东花城C                             '),trim('DSLAM      '),trim('192.168.96.120      '),trim('192.168.96.120          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('中产风尚中兴OLT                       '),trim('OLT        '),trim('192.168.126.5       '),trim('192.168.126.5(142.66-80)'), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('中产风尚中兴OLT                       '),trim('OLT        '),trim('192.168.126.6       '),trim('192.168.126.6           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金洲湾蓝屿华为OLT                     '),trim('OLT        '),trim('192.168.126.7       '),trim('192.168.126.7           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金洲湾蓝屿华为OLT                     '),trim('OLT        '),trim('192.168.126.7       '),trim('192.168.126.7           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('郦岛嘉园中兴OLT                       '),trim('OLT        '),trim('192.168.146.98      '),trim('192.168.146.98(96.127)'), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区华为OLT                       '),trim('OLT        '),trim('192.168.126.76      '),trim('192.168.126.76-140      '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局华为OLT6(FTTH)                    '),trim('OLT        '),trim('172.30.88.65        '),trim('172.30.88.65/26         '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('郦岛嘉园中兴OLT                       '),trim('OLT        '),trim('192.168.146.98      '),trim('192.168.146.98          '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('园丁小区华为OLT                       '),trim('OLT        '),trim('192.168.126.76      '),trim('192.168.126.76-140      '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('葵花公社01ZX9210                      '),trim('OLT        '),trim('192.168.96.51       '),trim('192.168.96.51           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('郦岛嘉园华为OLT                       '),trim('OLT        '),trim('192.168.234.1       '),trim('192.168.234.1/26        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金色年华华为OLT                       '),trim('OLT        '),trim('192.168.142.130     '),trim('192.168.142.130-161     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金泉小区华为OLT                       '),trim('OLT        '),trim('192.168.126.141     '),trim('192.168.126.141-196     '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局中兴OLT2                          '),trim('OLT        '),trim('192.168.126.3       '),trim('192.168.126.3           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('56局华为OLT                           '),trim('OLT        '),trim('192.168.126.2       '),trim('192.168.126.2           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('罗丈村C网机房wlan                     '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('俊发中心WLAN                          '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S7806-3                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('官房广场3IN1                          '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('50局自用                              '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('省交警中心(3IN1)                    '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金色年华A 3IN1                        '),trim('园区L2     '),trim('172.16.93.83        '),trim('172.16.93.83            '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('齐宝酒店(3IN1)                      '),trim('园区L2     '),trim('172.16.66.30        '),trim('172.16.66.30            '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('丹彤大厦(3IN1)                      '),trim('园区L2     '),trim('172.16.66.76        '),trim('172.16.66.76            '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('市检察院(3IN1)                      '),trim('园区L2     '),trim('172.16.66.77        '),trim('172.16.66.77            '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('江东大厦3IN1                          '),trim('园区L2     '),trim('172.16.66.109       '),trim('172.16.66.109-110      '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('金色年华B 3IN1                        '),trim('园区L2     '),trim('172.16.93.84        '),trim('172.16.93.84            '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('珠江源大酒店3IN1                      '),trim('园区L2     '),trim('172.16.93.251       '),trim('172.16.93.251           '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('科学技术信息学院3IN1                  '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('世博花园酒店3IN1                      '),trim('园区L2     '),trim('172.16.66.10        '),trim('172.16.66.10            '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('JinWangJiuDian-Hotel(WLAN)            '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));
INSERT INTO C_DEVICE (ID, NAME, ENTITYTYPECODE, NMIPADDRESS, MEMO, PARENTDEVICE_ID)VALUES (SEQ_C_DEVICE.NEXTVAL, trim('ShiBoHuaYuan-Hotel-2#Yuan(WLAN)       '),trim('园区L2     '),trim('                    '),trim('                        '), (SELECT T.ID FROM C_DEVICE T WHERE T.NAME=trim(' 56局HW S9306-1                ')));

